MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Role = 5589

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
440774 59.533.20 0 1 735260 Drawings and Prints 11 Print 731 Scene in a Farce called The Quaker           Sitter|Sitter|Artist 5589   William Parsons|John Bannister|Thomas Rowlandson British, 1735–1795 London|British, 1760–1836|British, London 1757–1827 London   Parsons, William|Bannister, John|Rowlandson, Thomas 56063   1735 |1760 |1757 1795 |1836 |1827 December 22, 1783 1783 1783 Hand-colored etching 34862 Sheet (inset): 8 3/8 × 11 1/2 in. (21.2 × 29.2 cm) Plate: 7 9/16 × 10 3/4 in. (19.2 × 27.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
440778 17.3.888-288 0 1 735266 Drawings and Prints 11 Print 731 Scene in a Farce called The Quaker           Sitter|Sitter|Artist 5589   John Bannister|William Parsons|Thomas Rowlandson British, 1760–1836|British, 1735–1795 London|British, London 1757–1827 London   Bannister, John|Parsons, William|Rowlandson, Thomas 56065   1760 |1735 |1757 1836 |1795 |1827 December 22, 1783 1783 1783 Etching 26137 Sheet: 9 11/16 × 12 7/8 in. (24.6 × 32.7 cm) Plate: 7 5/8 × 10 5/8 in. (19.3 × 27 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442236 1982.1165.3 0 0 739219 Drawings and Prints 11 Print 731 Helen and Margaret Folsom           Sitter|Sitter|Artist 5589   Margaret Winthrop Folsom|Helen Stuyvesant Folsom|Eastman Johnson American, 1842–1925|American, 1843–1882|American, Lovell, Maine 1824–1906 New York   Folsom, Margaret Winthrop|Folsom, Helen Stuyvesant|Johnson, Eastman 56412   1842 |1843 |1824 1925 |1882 |1906 1851–53 1851 1853 Lithography 29421 Image: 18 in. × 14 7/16 in. (45.7 × 36.7 cm) Sheet: 20 7/8 × 17 1/8 in. (53 × 43.5 cm) Gift of Frances Macy Thayer and Joan Macy Kaskell, 1982                       Prints 13   Metropolitan Museum of Art, New York, NY 1
458472 1976.602.21 0 1 774709 Drawings and Prints 11 Print 731 Les Gourmands           Sitter|Sitter|Artist 5589   James Boswell|Samuel Johnson|Anonymous, British, late 18th century British, Edinburgh, Scotland 1740–1795|British, Lichfield, Staffordshire 1709–1784 London   Boswell, James|Johnson, Samuel|Anonymous, British, 18th century late 58849   1740 |1709 |1750 1795 |1784 |1800 1780–1820 1780 1820 Etching 26137 Sheet (trimmed within plate): 10 7/8 × 8 3/8 in. (27.6 × 21.2 cm) Gift of Adele S. Gollin, 1976                       Prints 13   Metropolitan Museum of Art, New York, NY 1
458520 2017.223.13 0 0 774762 Drawings and Prints 11 Print; trade card 27201 View of General Joffre at the Italian front, from 'Europe During the War'         'Europe During the War' (Europa Durante La Guerra) 2966 Sitter|Sitter|Artist 5589   Marshal Joseph Joffre|Marshal Luigi Cadorna|Anonymous, 20th century French, Rivesaltes 1852–1931 Paris|Italian, Verbania 1850–1928 Bordighera   Joffre, Joseph Marshal|Cadorna, Luigi Marshal|Anonymous, 20th century 58863   1852 |1850 |1900 1931 |1928 |1999 ca. 1920 1915 1925 Commercial color lithograph 30785 Sheet: 4 5/16 × 2 3/4 in. (11 × 7 cm) Purchase, Jefferson R. Burdick Bequest, 2017                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
458814 59.533.1727 0 1 775453 Drawings and Prints 11 Print 731 Two Men Smoking and Drinking (Charles and Jack Bannister in Henry IV, Part I (?))           Sitter|Sitter|Artist 5589 Possibly|Possibly John Bannister|Charles Bannister|Thomas Rowlandson British, 1760–1836|British, 1738–1804|British, London 1757–1827 London   Bannister, John|Bannister, Charles|Rowlandson, Thomas 58905   1760 |1738 |1757 1836 |1804 |1827 1778–83 (?) 1778 1783 Etching 26137 Plate: 4 1/4 × 5 13/16 in. (10.8 × 14.8 cm) Sheet: 6 in. × 7 9/16 in. (15.2 × 19.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
464296 59.533.1874 0 0 786714 Drawings and Prints 11 Print 731 Scene in a Farce called The Quaker           Sitter|Sitter|Artist 5589   John Bannister|William Parsons|Thomas Rowlandson British, 1760–1836|British, 1735–1795 London|British, London 1757–1827 London   Bannister, John|Parsons, William|Rowlandson, Thomas 56065   1760 |1735 |1757 1836 |1795 |1827 December 22, 1783 1783 1783 Hand-colored etching 34862 Plate: 7 3/8 × 10 9/16 in. (18.8 × 26.8 cm) Sheet: 9 × 12 in. (22.9 × 30.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 141.678ms · Data license: CC0 · Data source: metmuseum/openaccess